DDB

Basic and Crystal syntax.

Overloads
Arguments
Returns

Number value

Action

DDB returns a Number specifying the depreciation of an asset for a specific time period, using the double-declining balance method or some other method as specified by the factor argument.

Examples

The following examples are applicable to both Basic and Crystal syntax:

Suppose a company purchases a fleet of cars for $500,000. The cars have a lifetime of 10 years and a salvage value of $60,000. They are depreciated using the double-declining method.

DDB (500000, 60000, 10, 1)

Returns 100000. The first year's depreciation is $100,000.

DDB (500000, 60000, 10, 4)

Returns 51200. The fourth year's depreciation is $51,200.

DDB (500000, 60000, 10, 10)

Returns 7108.864. The final year's depreciation is $7,108.86.

Comment

This function is designed to work like the Visual Basic function of the same name.



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com